package com.lyouu.dataminer.db;

public class DbConstants {
	public static final String DRIVER = "com.mysql.jdbc.Driver"; // Windows
	// public static final String DRIVER
	// ="org.apache.mysql.jdbc.EmbeddedDriver"; // Mac OS
	public static final String DB_LYOUU_SRC = "jdbc:mysql://localhost/lyouu_src?"
              + "user=root&password=lyouu13";
	public static final String DB_LYOUU = "jdbc:mysql://localhost/db_lyouu?"
            + "user=root&password=lyouu13";
	public static final String DB_LYOUU_BAK = "jdbc:mysql://localhost/db_lyouu_bak-140722?"
            + "user=root&password=lyouu13";
	
	//lyouu_src database
	//bus tour
	public static final String LYOUU_SRC_BUS_TOUR_AREA = "area";
	public static final String LYOUU_SRC_BUS_TOUR_TITLE = "title";
	public static final String LYOUU_SRC_BUS_TOUR_PAGE_URL = "page_url";
	public static final String LYOUU_SRC_BUS_TOUR_ROUTE = "route";
	public static final String LYOUU_SRC_BUS_TOUR_IMG_URL = "img_url";
	public static final String LYOUU_SRC_BUS_TOUR_HIGHLIGHT = "highlights";
	public static final String LYOUU_SRC_BUS_TOUR_DEPART_CITY = "depart_city";
	public static final String LYOUU_SRC_BUS_TOUR_RETURN_CITY = "return_city";
	public static final String LYOUU_SRC_BUS_TOUR_SCHEDULE = "schedule";
	public static final String LYOUU_SRC_BUS_TOUR_GROUP_ID = "group_id";
	public static final String LYOUU_SRC_BUS_TOUR_TRAVEL_DATE = "travel_date";
	public static final String LYOUU_SRC_BUS_TOUR_PRICE = "price";
	public static final String LYOUU_SRC_BUS_TOUR_STATUS = "status";
	public static final String LYOUU_SRC_BUS_TOUR_ORDER_URL = "order_url";
	public static final String LYOUU_SRC_BUS_TOUR_CONTENT_URL = "content_url";
	public static final String LYOUU_SRC_BUS_TOUR_BRIEF = "brief";
	public static final String LYOUU_SRC_BUS_TOUR_TRAVEL_GROUP = "travel_group";
	//cruise tour
	public static final String LYOUU_SRC_CRUISE_TOUR_AREA = "area";
	public static final String LYOUU_SRC_CRUISE_TOUR_TITLE = "title";
	public static final String LYOUU_SRC_CRUISE_TOUR_PAGE_URL = "page_url";
	public static final String LYOUU_SRC_CRUISE_TOUR_ROUTE = "route";
	public static final String LYOUU_SRC_CRUISE_TOUR_IMG_URL = "img_url";
	public static final String LYOUU_SRC_CRUISE_TOUR_HIGHLIGHT = "highlights";
	public static final String LYOUU_SRC_CRUISE_TOUR_DEPART_CITY = "depart_city";
	public static final String LYOUU_SRC_CRUISE_TOUR_RETURN_CITY = "return_city";
	public static final String LYOUU_SRC_CRUISE_TOUR_SCHEDULE = "schedule";
	public static final String LYOUU_SRC_CRUISE_TOUR_GROUP_ID = "group_id";
	public static final String LYOUU_SRC_CRUISE_TOUR_TRAVEL_DATE = "travel_date";
	public static final String LYOUU_SRC_CRUISE_TOUR_PRICE = "price";
	public static final String LYOUU_SRC_CRUISE_TOUR_STATUS = "status";
	public static final String LYOUU_SRC_CRUISE_TOUR_ORDER_URL = "order_url";
	public static final String LYOUU_SRC_CRUISE_TOUR_CONTENT_URL = "content_url";
	public static final String LYOUU_SRC_CRUISE_TOUR_BRIEF = "brief";
	public static final String LYOUU_SRC_CRUISE_TOUR_TRAVEL_GROUP = "travel_group";
	
	//db_lyouu database
	public static final String DB_LYOUU_MD_SUBJECT_NAME = "name";
}
